package com.tro.mail.dao.entity;

import com.tro.common.util.mybatis.Page;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class MailMainExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Page page;

    public MailMainExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setPage(Page page) {
        this.page=page;
    }

    public Page getPage() {
        return page;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andMailTitleIsNull() {
            addCriterion("MAIL_TITLE is null");
            return (Criteria) this;
        }

        public Criteria andMailTitleIsNotNull() {
            addCriterion("MAIL_TITLE is not null");
            return (Criteria) this;
        }

        public Criteria andMailTitleEqualTo(String value) {
            addCriterion("MAIL_TITLE =", value, "mailTitle");
            return (Criteria) this;
        }

        public Criteria andMailTitleNotEqualTo(String value) {
            addCriterion("MAIL_TITLE <>", value, "mailTitle");
            return (Criteria) this;
        }

        public Criteria andMailTitleGreaterThan(String value) {
            addCriterion("MAIL_TITLE >", value, "mailTitle");
            return (Criteria) this;
        }

        public Criteria andMailTitleGreaterThanOrEqualTo(String value) {
            addCriterion("MAIL_TITLE >=", value, "mailTitle");
            return (Criteria) this;
        }

        public Criteria andMailTitleLessThan(String value) {
            addCriterion("MAIL_TITLE <", value, "mailTitle");
            return (Criteria) this;
        }

        public Criteria andMailTitleLessThanOrEqualTo(String value) {
            addCriterion("MAIL_TITLE <=", value, "mailTitle");
            return (Criteria) this;
        }

        public Criteria andMailTitleLike(String value) {
            addCriterion("MAIL_TITLE like", value, "mailTitle");
            return (Criteria) this;
        }

        public Criteria andMailTitleNotLike(String value) {
            addCriterion("MAIL_TITLE not like", value, "mailTitle");
            return (Criteria) this;
        }

        public Criteria andMailTitleIn(List<String> values) {
            addCriterion("MAIL_TITLE in", values, "mailTitle");
            return (Criteria) this;
        }

        public Criteria andMailTitleNotIn(List<String> values) {
            addCriterion("MAIL_TITLE not in", values, "mailTitle");
            return (Criteria) this;
        }

        public Criteria andMailTitleBetween(String value1, String value2) {
            addCriterion("MAIL_TITLE between", value1, value2, "mailTitle");
            return (Criteria) this;
        }

        public Criteria andMailTitleNotBetween(String value1, String value2) {
            addCriterion("MAIL_TITLE not between", value1, value2, "mailTitle");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIsNull() {
            addCriterion("CREATE_USER_ID is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIsNotNull() {
            addCriterion("CREATE_USER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdEqualTo(String value) {
            addCriterion("CREATE_USER_ID =", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotEqualTo(String value) {
            addCriterion("CREATE_USER_ID <>", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdGreaterThan(String value) {
            addCriterion("CREATE_USER_ID >", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_USER_ID >=", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLessThan(String value) {
            addCriterion("CREATE_USER_ID <", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLessThanOrEqualTo(String value) {
            addCriterion("CREATE_USER_ID <=", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLike(String value) {
            addCriterion("CREATE_USER_ID like", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotLike(String value) {
            addCriterion("CREATE_USER_ID not like", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIn(List<String> values) {
            addCriterion("CREATE_USER_ID in", values, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotIn(List<String> values) {
            addCriterion("CREATE_USER_ID not in", values, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdBetween(String value1, String value2) {
            addCriterion("CREATE_USER_ID between", value1, value2, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotBetween(String value1, String value2) {
            addCriterion("CREATE_USER_ID not between", value1, value2, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andIsUrgentIsNull() {
            addCriterion("IS_URGENT is null");
            return (Criteria) this;
        }

        public Criteria andIsUrgentIsNotNull() {
            addCriterion("IS_URGENT is not null");
            return (Criteria) this;
        }

        public Criteria andIsUrgentEqualTo(Short value) {
            addCriterion("IS_URGENT =", value, "isUrgent");
            return (Criteria) this;
        }

        public Criteria andIsUrgentNotEqualTo(Short value) {
            addCriterion("IS_URGENT <>", value, "isUrgent");
            return (Criteria) this;
        }

        public Criteria andIsUrgentGreaterThan(Short value) {
            addCriterion("IS_URGENT >", value, "isUrgent");
            return (Criteria) this;
        }

        public Criteria andIsUrgentGreaterThanOrEqualTo(Short value) {
            addCriterion("IS_URGENT >=", value, "isUrgent");
            return (Criteria) this;
        }

        public Criteria andIsUrgentLessThan(Short value) {
            addCriterion("IS_URGENT <", value, "isUrgent");
            return (Criteria) this;
        }

        public Criteria andIsUrgentLessThanOrEqualTo(Short value) {
            addCriterion("IS_URGENT <=", value, "isUrgent");
            return (Criteria) this;
        }

        public Criteria andIsUrgentIn(List<Short> values) {
            addCriterion("IS_URGENT in", values, "isUrgent");
            return (Criteria) this;
        }

        public Criteria andIsUrgentNotIn(List<Short> values) {
            addCriterion("IS_URGENT not in", values, "isUrgent");
            return (Criteria) this;
        }

        public Criteria andIsUrgentBetween(Short value1, Short value2) {
            addCriterion("IS_URGENT between", value1, value2, "isUrgent");
            return (Criteria) this;
        }

        public Criteria andIsUrgentNotBetween(Short value1, Short value2) {
            addCriterion("IS_URGENT not between", value1, value2, "isUrgent");
            return (Criteria) this;
        }

        public Criteria andIsReceiptIsNull() {
            addCriterion("IS_RECEIPT is null");
            return (Criteria) this;
        }

        public Criteria andIsReceiptIsNotNull() {
            addCriterion("IS_RECEIPT is not null");
            return (Criteria) this;
        }

        public Criteria andIsReceiptEqualTo(Short value) {
            addCriterion("IS_RECEIPT =", value, "isReceipt");
            return (Criteria) this;
        }

        public Criteria andIsReceiptNotEqualTo(Short value) {
            addCriterion("IS_RECEIPT <>", value, "isReceipt");
            return (Criteria) this;
        }

        public Criteria andIsReceiptGreaterThan(Short value) {
            addCriterion("IS_RECEIPT >", value, "isReceipt");
            return (Criteria) this;
        }

        public Criteria andIsReceiptGreaterThanOrEqualTo(Short value) {
            addCriterion("IS_RECEIPT >=", value, "isReceipt");
            return (Criteria) this;
        }

        public Criteria andIsReceiptLessThan(Short value) {
            addCriterion("IS_RECEIPT <", value, "isReceipt");
            return (Criteria) this;
        }

        public Criteria andIsReceiptLessThanOrEqualTo(Short value) {
            addCriterion("IS_RECEIPT <=", value, "isReceipt");
            return (Criteria) this;
        }

        public Criteria andIsReceiptIn(List<Short> values) {
            addCriterion("IS_RECEIPT in", values, "isReceipt");
            return (Criteria) this;
        }

        public Criteria andIsReceiptNotIn(List<Short> values) {
            addCriterion("IS_RECEIPT not in", values, "isReceipt");
            return (Criteria) this;
        }

        public Criteria andIsReceiptBetween(Short value1, Short value2) {
            addCriterion("IS_RECEIPT between", value1, value2, "isReceipt");
            return (Criteria) this;
        }

        public Criteria andIsReceiptNotBetween(Short value1, Short value2) {
            addCriterion("IS_RECEIPT not between", value1, value2, "isReceipt");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameIsNull() {
            addCriterion("CREATE_USER_NAME is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameIsNotNull() {
            addCriterion("CREATE_USER_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameEqualTo(String value) {
            addCriterion("CREATE_USER_NAME =", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameNotEqualTo(String value) {
            addCriterion("CREATE_USER_NAME <>", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameGreaterThan(String value) {
            addCriterion("CREATE_USER_NAME >", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_USER_NAME >=", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameLessThan(String value) {
            addCriterion("CREATE_USER_NAME <", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameLessThanOrEqualTo(String value) {
            addCriterion("CREATE_USER_NAME <=", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameLike(String value) {
            addCriterion("CREATE_USER_NAME like", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameNotLike(String value) {
            addCriterion("CREATE_USER_NAME not like", value, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameIn(List<String> values) {
            addCriterion("CREATE_USER_NAME in", values, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameNotIn(List<String> values) {
            addCriterion("CREATE_USER_NAME not in", values, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameBetween(String value1, String value2) {
            addCriterion("CREATE_USER_NAME between", value1, value2, "createUserName");
            return (Criteria) this;
        }

        public Criteria andCreateUserNameNotBetween(String value1, String value2) {
            addCriterion("CREATE_USER_NAME not between", value1, value2, "createUserName");
            return (Criteria) this;
        }

        public Criteria andMailStatuIsNull() {
            addCriterion("MAIL_STATU is null");
            return (Criteria) this;
        }

        public Criteria andMailStatuIsNotNull() {
            addCriterion("MAIL_STATU is not null");
            return (Criteria) this;
        }

        public Criteria andMailStatuEqualTo(Short value) {
            addCriterion("MAIL_STATU =", value, "mailStatu");
            return (Criteria) this;
        }

        public Criteria andMailStatuNotEqualTo(Short value) {
            addCriterion("MAIL_STATU <>", value, "mailStatu");
            return (Criteria) this;
        }

        public Criteria andMailStatuGreaterThan(Short value) {
            addCriterion("MAIL_STATU >", value, "mailStatu");
            return (Criteria) this;
        }

        public Criteria andMailStatuGreaterThanOrEqualTo(Short value) {
            addCriterion("MAIL_STATU >=", value, "mailStatu");
            return (Criteria) this;
        }

        public Criteria andMailStatuLessThan(Short value) {
            addCriterion("MAIL_STATU <", value, "mailStatu");
            return (Criteria) this;
        }

        public Criteria andMailStatuLessThanOrEqualTo(Short value) {
            addCriterion("MAIL_STATU <=", value, "mailStatu");
            return (Criteria) this;
        }

        public Criteria andMailStatuIn(List<Short> values) {
            addCriterion("MAIL_STATU in", values, "mailStatu");
            return (Criteria) this;
        }

        public Criteria andMailStatuNotIn(List<Short> values) {
            addCriterion("MAIL_STATU not in", values, "mailStatu");
            return (Criteria) this;
        }

        public Criteria andMailStatuBetween(Short value1, Short value2) {
            addCriterion("MAIL_STATU between", value1, value2, "mailStatu");
            return (Criteria) this;
        }

        public Criteria andMailStatuNotBetween(Short value1, Short value2) {
            addCriterion("MAIL_STATU not between", value1, value2, "mailStatu");
            return (Criteria) this;
        }

        public Criteria andForderIdIsNull() {
            addCriterion("FORDER_ID is null");
            return (Criteria) this;
        }

        public Criteria andForderIdIsNotNull() {
            addCriterion("FORDER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andForderIdEqualTo(Long value) {
            addCriterion("FORDER_ID =", value, "forderId");
            return (Criteria) this;
        }

        public Criteria andForderIdNotEqualTo(Long value) {
            addCriterion("FORDER_ID <>", value, "forderId");
            return (Criteria) this;
        }

        public Criteria andForderIdGreaterThan(Long value) {
            addCriterion("FORDER_ID >", value, "forderId");
            return (Criteria) this;
        }

        public Criteria andForderIdGreaterThanOrEqualTo(Long value) {
            addCriterion("FORDER_ID >=", value, "forderId");
            return (Criteria) this;
        }

        public Criteria andForderIdLessThan(Long value) {
            addCriterion("FORDER_ID <", value, "forderId");
            return (Criteria) this;
        }

        public Criteria andForderIdLessThanOrEqualTo(Long value) {
            addCriterion("FORDER_ID <=", value, "forderId");
            return (Criteria) this;
        }

        public Criteria andForderIdIn(List<Long> values) {
            addCriterion("FORDER_ID in", values, "forderId");
            return (Criteria) this;
        }

        public Criteria andForderIdNotIn(List<Long> values) {
            addCriterion("FORDER_ID not in", values, "forderId");
            return (Criteria) this;
        }

        public Criteria andForderIdBetween(Long value1, Long value2) {
            addCriterion("FORDER_ID between", value1, value2, "forderId");
            return (Criteria) this;
        }

        public Criteria andForderIdNotBetween(Long value1, Long value2) {
            addCriterion("FORDER_ID not between", value1, value2, "forderId");
            return (Criteria) this;
        }

        public Criteria andIsStartIsNull() {
            addCriterion("IS_START is null");
            return (Criteria) this;
        }

        public Criteria andIsStartIsNotNull() {
            addCriterion("IS_START is not null");
            return (Criteria) this;
        }

        public Criteria andIsStartEqualTo(Short value) {
            addCriterion("IS_START =", value, "isStart");
            return (Criteria) this;
        }

        public Criteria andIsStartNotEqualTo(Short value) {
            addCriterion("IS_START <>", value, "isStart");
            return (Criteria) this;
        }

        public Criteria andIsStartGreaterThan(Short value) {
            addCriterion("IS_START >", value, "isStart");
            return (Criteria) this;
        }

        public Criteria andIsStartGreaterThanOrEqualTo(Short value) {
            addCriterion("IS_START >=", value, "isStart");
            return (Criteria) this;
        }

        public Criteria andIsStartLessThan(Short value) {
            addCriterion("IS_START <", value, "isStart");
            return (Criteria) this;
        }

        public Criteria andIsStartLessThanOrEqualTo(Short value) {
            addCriterion("IS_START <=", value, "isStart");
            return (Criteria) this;
        }

        public Criteria andIsStartIn(List<Short> values) {
            addCriterion("IS_START in", values, "isStart");
            return (Criteria) this;
        }

        public Criteria andIsStartNotIn(List<Short> values) {
            addCriterion("IS_START not in", values, "isStart");
            return (Criteria) this;
        }

        public Criteria andIsStartBetween(Short value1, Short value2) {
            addCriterion("IS_START between", value1, value2, "isStart");
            return (Criteria) this;
        }

        public Criteria andIsStartNotBetween(Short value1, Short value2) {
            addCriterion("IS_START not between", value1, value2, "isStart");
            return (Criteria) this;
        }

        public Criteria andConsigneeValIsNull() {
            addCriterion("CONSIGNEE_VAL is null");
            return (Criteria) this;
        }

        public Criteria andConsigneeValIsNotNull() {
            addCriterion("CONSIGNEE_VAL is not null");
            return (Criteria) this;
        }

        public Criteria andConsigneeValEqualTo(String value) {
            addCriterion("CONSIGNEE_VAL =", value, "consigneeVal");
            return (Criteria) this;
        }

        public Criteria andConsigneeValNotEqualTo(String value) {
            addCriterion("CONSIGNEE_VAL <>", value, "consigneeVal");
            return (Criteria) this;
        }

        public Criteria andConsigneeValGreaterThan(String value) {
            addCriterion("CONSIGNEE_VAL >", value, "consigneeVal");
            return (Criteria) this;
        }

        public Criteria andConsigneeValGreaterThanOrEqualTo(String value) {
            addCriterion("CONSIGNEE_VAL >=", value, "consigneeVal");
            return (Criteria) this;
        }

        public Criteria andConsigneeValLessThan(String value) {
            addCriterion("CONSIGNEE_VAL <", value, "consigneeVal");
            return (Criteria) this;
        }

        public Criteria andConsigneeValLessThanOrEqualTo(String value) {
            addCriterion("CONSIGNEE_VAL <=", value, "consigneeVal");
            return (Criteria) this;
        }

        public Criteria andConsigneeValLike(String value) {
            addCriterion("CONSIGNEE_VAL like", value, "consigneeVal");
            return (Criteria) this;
        }

        public Criteria andConsigneeValNotLike(String value) {
            addCriterion("CONSIGNEE_VAL not like", value, "consigneeVal");
            return (Criteria) this;
        }

        public Criteria andConsigneeValIn(List<String> values) {
            addCriterion("CONSIGNEE_VAL in", values, "consigneeVal");
            return (Criteria) this;
        }

        public Criteria andConsigneeValNotIn(List<String> values) {
            addCriterion("CONSIGNEE_VAL not in", values, "consigneeVal");
            return (Criteria) this;
        }

        public Criteria andConsigneeValBetween(String value1, String value2) {
            addCriterion("CONSIGNEE_VAL between", value1, value2, "consigneeVal");
            return (Criteria) this;
        }

        public Criteria andConsigneeValNotBetween(String value1, String value2) {
            addCriterion("CONSIGNEE_VAL not between", value1, value2, "consigneeVal");
            return (Criteria) this;
        }

        public Criteria andCcValIsNull() {
            addCriterion("CC_VAL is null");
            return (Criteria) this;
        }

        public Criteria andCcValIsNotNull() {
            addCriterion("CC_VAL is not null");
            return (Criteria) this;
        }

        public Criteria andCcValEqualTo(String value) {
            addCriterion("CC_VAL =", value, "ccVal");
            return (Criteria) this;
        }

        public Criteria andCcValNotEqualTo(String value) {
            addCriterion("CC_VAL <>", value, "ccVal");
            return (Criteria) this;
        }

        public Criteria andCcValGreaterThan(String value) {
            addCriterion("CC_VAL >", value, "ccVal");
            return (Criteria) this;
        }

        public Criteria andCcValGreaterThanOrEqualTo(String value) {
            addCriterion("CC_VAL >=", value, "ccVal");
            return (Criteria) this;
        }

        public Criteria andCcValLessThan(String value) {
            addCriterion("CC_VAL <", value, "ccVal");
            return (Criteria) this;
        }

        public Criteria andCcValLessThanOrEqualTo(String value) {
            addCriterion("CC_VAL <=", value, "ccVal");
            return (Criteria) this;
        }

        public Criteria andCcValLike(String value) {
            addCriterion("CC_VAL like", value, "ccVal");
            return (Criteria) this;
        }

        public Criteria andCcValNotLike(String value) {
            addCriterion("CC_VAL not like", value, "ccVal");
            return (Criteria) this;
        }

        public Criteria andCcValIn(List<String> values) {
            addCriterion("CC_VAL in", values, "ccVal");
            return (Criteria) this;
        }

        public Criteria andCcValNotIn(List<String> values) {
            addCriterion("CC_VAL not in", values, "ccVal");
            return (Criteria) this;
        }

        public Criteria andCcValBetween(String value1, String value2) {
            addCriterion("CC_VAL between", value1, value2, "ccVal");
            return (Criteria) this;
        }

        public Criteria andCcValNotBetween(String value1, String value2) {
            addCriterion("CC_VAL not between", value1, value2, "ccVal");
            return (Criteria) this;
        }

        public Criteria andSecretValIsNull() {
            addCriterion("SECRET_VAL is null");
            return (Criteria) this;
        }

        public Criteria andSecretValIsNotNull() {
            addCriterion("SECRET_VAL is not null");
            return (Criteria) this;
        }

        public Criteria andSecretValEqualTo(String value) {
            addCriterion("SECRET_VAL =", value, "secretVal");
            return (Criteria) this;
        }

        public Criteria andSecretValNotEqualTo(String value) {
            addCriterion("SECRET_VAL <>", value, "secretVal");
            return (Criteria) this;
        }

        public Criteria andSecretValGreaterThan(String value) {
            addCriterion("SECRET_VAL >", value, "secretVal");
            return (Criteria) this;
        }

        public Criteria andSecretValGreaterThanOrEqualTo(String value) {
            addCriterion("SECRET_VAL >=", value, "secretVal");
            return (Criteria) this;
        }

        public Criteria andSecretValLessThan(String value) {
            addCriterion("SECRET_VAL <", value, "secretVal");
            return (Criteria) this;
        }

        public Criteria andSecretValLessThanOrEqualTo(String value) {
            addCriterion("SECRET_VAL <=", value, "secretVal");
            return (Criteria) this;
        }

        public Criteria andSecretValLike(String value) {
            addCriterion("SECRET_VAL like", value, "secretVal");
            return (Criteria) this;
        }

        public Criteria andSecretValNotLike(String value) {
            addCriterion("SECRET_VAL not like", value, "secretVal");
            return (Criteria) this;
        }

        public Criteria andSecretValIn(List<String> values) {
            addCriterion("SECRET_VAL in", values, "secretVal");
            return (Criteria) this;
        }

        public Criteria andSecretValNotIn(List<String> values) {
            addCriterion("SECRET_VAL not in", values, "secretVal");
            return (Criteria) this;
        }

        public Criteria andSecretValBetween(String value1, String value2) {
            addCriterion("SECRET_VAL between", value1, value2, "secretVal");
            return (Criteria) this;
        }

        public Criteria andSecretValNotBetween(String value1, String value2) {
            addCriterion("SECRET_VAL not between", value1, value2, "secretVal");
            return (Criteria) this;
        }

        public Criteria andAnnexValIsNull() {
            addCriterion("ANNEX_VAL is null");
            return (Criteria) this;
        }

        public Criteria andAnnexValIsNotNull() {
            addCriterion("ANNEX_VAL is not null");
            return (Criteria) this;
        }

        public Criteria andAnnexValEqualTo(String value) {
            addCriterion("ANNEX_VAL =", value, "annexVal");
            return (Criteria) this;
        }

        public Criteria andAnnexValNotEqualTo(String value) {
            addCriterion("ANNEX_VAL <>", value, "annexVal");
            return (Criteria) this;
        }

        public Criteria andAnnexValGreaterThan(String value) {
            addCriterion("ANNEX_VAL >", value, "annexVal");
            return (Criteria) this;
        }

        public Criteria andAnnexValGreaterThanOrEqualTo(String value) {
            addCriterion("ANNEX_VAL >=", value, "annexVal");
            return (Criteria) this;
        }

        public Criteria andAnnexValLessThan(String value) {
            addCriterion("ANNEX_VAL <", value, "annexVal");
            return (Criteria) this;
        }

        public Criteria andAnnexValLessThanOrEqualTo(String value) {
            addCriterion("ANNEX_VAL <=", value, "annexVal");
            return (Criteria) this;
        }

        public Criteria andAnnexValLike(String value) {
            addCriterion("ANNEX_VAL like", value, "annexVal");
            return (Criteria) this;
        }

        public Criteria andAnnexValNotLike(String value) {
            addCriterion("ANNEX_VAL not like", value, "annexVal");
            return (Criteria) this;
        }

        public Criteria andAnnexValIn(List<String> values) {
            addCriterion("ANNEX_VAL in", values, "annexVal");
            return (Criteria) this;
        }

        public Criteria andAnnexValNotIn(List<String> values) {
            addCriterion("ANNEX_VAL not in", values, "annexVal");
            return (Criteria) this;
        }

        public Criteria andAnnexValBetween(String value1, String value2) {
            addCriterion("ANNEX_VAL between", value1, value2, "annexVal");
            return (Criteria) this;
        }

        public Criteria andAnnexValNotBetween(String value1, String value2) {
            addCriterion("ANNEX_VAL not between", value1, value2, "annexVal");
            return (Criteria) this;
        }

        public Criteria andConsigneeTeamIsNull() {
            addCriterion("CONSIGNEE_TEAM is null");
            return (Criteria) this;
        }

        public Criteria andConsigneeTeamIsNotNull() {
            addCriterion("CONSIGNEE_TEAM is not null");
            return (Criteria) this;
        }

        public Criteria andConsigneeTeamEqualTo(String value) {
            addCriterion("CONSIGNEE_TEAM =", value, "consigneeTeam");
            return (Criteria) this;
        }

        public Criteria andConsigneeTeamNotEqualTo(String value) {
            addCriterion("CONSIGNEE_TEAM <>", value, "consigneeTeam");
            return (Criteria) this;
        }

        public Criteria andConsigneeTeamGreaterThan(String value) {
            addCriterion("CONSIGNEE_TEAM >", value, "consigneeTeam");
            return (Criteria) this;
        }

        public Criteria andConsigneeTeamGreaterThanOrEqualTo(String value) {
            addCriterion("CONSIGNEE_TEAM >=", value, "consigneeTeam");
            return (Criteria) this;
        }

        public Criteria andConsigneeTeamLessThan(String value) {
            addCriterion("CONSIGNEE_TEAM <", value, "consigneeTeam");
            return (Criteria) this;
        }

        public Criteria andConsigneeTeamLessThanOrEqualTo(String value) {
            addCriterion("CONSIGNEE_TEAM <=", value, "consigneeTeam");
            return (Criteria) this;
        }

        public Criteria andConsigneeTeamLike(String value) {
            addCriterion("CONSIGNEE_TEAM like", value, "consigneeTeam");
            return (Criteria) this;
        }

        public Criteria andConsigneeTeamNotLike(String value) {
            addCriterion("CONSIGNEE_TEAM not like", value, "consigneeTeam");
            return (Criteria) this;
        }

        public Criteria andConsigneeTeamIn(List<String> values) {
            addCriterion("CONSIGNEE_TEAM in", values, "consigneeTeam");
            return (Criteria) this;
        }

        public Criteria andConsigneeTeamNotIn(List<String> values) {
            addCriterion("CONSIGNEE_TEAM not in", values, "consigneeTeam");
            return (Criteria) this;
        }

        public Criteria andConsigneeTeamBetween(String value1, String value2) {
            addCriterion("CONSIGNEE_TEAM between", value1, value2, "consigneeTeam");
            return (Criteria) this;
        }

        public Criteria andConsigneeTeamNotBetween(String value1, String value2) {
            addCriterion("CONSIGNEE_TEAM not between", value1, value2, "consigneeTeam");
            return (Criteria) this;
        }

        public Criteria andCcTeamIsNull() {
            addCriterion("CC_TEAM is null");
            return (Criteria) this;
        }

        public Criteria andCcTeamIsNotNull() {
            addCriterion("CC_TEAM is not null");
            return (Criteria) this;
        }

        public Criteria andCcTeamEqualTo(String value) {
            addCriterion("CC_TEAM =", value, "ccTeam");
            return (Criteria) this;
        }

        public Criteria andCcTeamNotEqualTo(String value) {
            addCriterion("CC_TEAM <>", value, "ccTeam");
            return (Criteria) this;
        }

        public Criteria andCcTeamGreaterThan(String value) {
            addCriterion("CC_TEAM >", value, "ccTeam");
            return (Criteria) this;
        }

        public Criteria andCcTeamGreaterThanOrEqualTo(String value) {
            addCriterion("CC_TEAM >=", value, "ccTeam");
            return (Criteria) this;
        }

        public Criteria andCcTeamLessThan(String value) {
            addCriterion("CC_TEAM <", value, "ccTeam");
            return (Criteria) this;
        }

        public Criteria andCcTeamLessThanOrEqualTo(String value) {
            addCriterion("CC_TEAM <=", value, "ccTeam");
            return (Criteria) this;
        }

        public Criteria andCcTeamLike(String value) {
            addCriterion("CC_TEAM like", value, "ccTeam");
            return (Criteria) this;
        }

        public Criteria andCcTeamNotLike(String value) {
            addCriterion("CC_TEAM not like", value, "ccTeam");
            return (Criteria) this;
        }

        public Criteria andCcTeamIn(List<String> values) {
            addCriterion("CC_TEAM in", values, "ccTeam");
            return (Criteria) this;
        }

        public Criteria andCcTeamNotIn(List<String> values) {
            addCriterion("CC_TEAM not in", values, "ccTeam");
            return (Criteria) this;
        }

        public Criteria andCcTeamBetween(String value1, String value2) {
            addCriterion("CC_TEAM between", value1, value2, "ccTeam");
            return (Criteria) this;
        }

        public Criteria andCcTeamNotBetween(String value1, String value2) {
            addCriterion("CC_TEAM not between", value1, value2, "ccTeam");
            return (Criteria) this;
        }

        public Criteria andSecretTeamIsNull() {
            addCriterion("SECRET_TEAM is null");
            return (Criteria) this;
        }

        public Criteria andSecretTeamIsNotNull() {
            addCriterion("SECRET_TEAM is not null");
            return (Criteria) this;
        }

        public Criteria andSecretTeamEqualTo(String value) {
            addCriterion("SECRET_TEAM =", value, "secretTeam");
            return (Criteria) this;
        }

        public Criteria andSecretTeamNotEqualTo(String value) {
            addCriterion("SECRET_TEAM <>", value, "secretTeam");
            return (Criteria) this;
        }

        public Criteria andSecretTeamGreaterThan(String value) {
            addCriterion("SECRET_TEAM >", value, "secretTeam");
            return (Criteria) this;
        }

        public Criteria andSecretTeamGreaterThanOrEqualTo(String value) {
            addCriterion("SECRET_TEAM >=", value, "secretTeam");
            return (Criteria) this;
        }

        public Criteria andSecretTeamLessThan(String value) {
            addCriterion("SECRET_TEAM <", value, "secretTeam");
            return (Criteria) this;
        }

        public Criteria andSecretTeamLessThanOrEqualTo(String value) {
            addCriterion("SECRET_TEAM <=", value, "secretTeam");
            return (Criteria) this;
        }

        public Criteria andSecretTeamLike(String value) {
            addCriterion("SECRET_TEAM like", value, "secretTeam");
            return (Criteria) this;
        }

        public Criteria andSecretTeamNotLike(String value) {
            addCriterion("SECRET_TEAM not like", value, "secretTeam");
            return (Criteria) this;
        }

        public Criteria andSecretTeamIn(List<String> values) {
            addCriterion("SECRET_TEAM in", values, "secretTeam");
            return (Criteria) this;
        }

        public Criteria andSecretTeamNotIn(List<String> values) {
            addCriterion("SECRET_TEAM not in", values, "secretTeam");
            return (Criteria) this;
        }

        public Criteria andSecretTeamBetween(String value1, String value2) {
            addCriterion("SECRET_TEAM between", value1, value2, "secretTeam");
            return (Criteria) this;
        }

        public Criteria andSecretTeamNotBetween(String value1, String value2) {
            addCriterion("SECRET_TEAM not between", value1, value2, "secretTeam");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}